How to: Use the MAX function to determine highest value in specified range.
Solution:
Select the cell where the result of the MAX function is to be displayed. Enter =MAX(<cell range>), where <cell range> is a range of cells.
NOTE: The MAX function returns the highest value of a specified range.
1) Select the cell where the result of the MAX function is to be displayed. (The cell is highlighted.)
2) Type an equal sign and the MAX command:
=MAX()
3) Do one of the following to specify the cell range to which the MAX command applies:
a) Type the range reference within the parentheses of the MAX command.
EXAMPLE: =MAX(D5:D10)
NOTE: For multiple ranges, separate each range with a comma. No spaces should exist in the formula.
b) Select the desired range with the mouse.
NOTE: Be sure that the range is included in parentheses. For multiple ranges, separate each range with a comma.
4) Press ENTER. (Excel displays the highest value of the specified range in the selected cell.)
